﻿
if COL_LENGTH('ERPStore_BanishedProductBySource', 'CreationDate') is null
Begin
	alter table ERPStore_BanishedProductBySource add CreationDate datetime null
end
Go

update ERPStore_BanishedProductBySource 
set CreationDate = GetDate()
Go

alter table ERPStore_BanishedProductBySource alter column CreationDate datetime not null
Go
